The Debtors Statement is the primary external document used in the control of customers accounts, and the collection of funds from credit account customers. Typically a Debtors Statement is produced for each account at the end of each month after all relevant entries have been completed for the month. i.e Invoicing and Cash Receipts.
* To view/print a continuous run of selected, or all Debtor Statements, go to; Reports > Debtors > Statements.
Select a Debtor Key with a right click, or F12 to search.
Press the 'Compute' button for an up to date detailed listing of invoices and payments.
Click on the invoice reference number to drill down and view individual invoice details.
In this example, three unpaid invoices exist.
In the following screeen shots, progressive payments are made, marking these invoices as paid, and the balance of the Debtor Statement is reduced to zero.
* Progressive payments of invoices are processed through; Documents > Debtor Receipt.
Here, two invoice payments are received, and entered into; Debtor > Receipt.
Invoice 00139 remains unpaid with a balance of 93.50.
To provide a further example, payment is received here for 90.00.
A balance of 3.50 remains and is marked with 'P'.
A further payment is then received for the outstanding 3.50.
This results in a balance of zero.
Debtor Statement
Prerequisites: The Debtor must exist in the Lilac3 Database.
Name: Type in the debtor’s key, for whom you wish to generate a statement for, or leave blank if you wish to do a continuous print. Period: The current accounting period is displayed here. It is established when you sign in. Date: The date to print on statement. This should represent the date the statement was issued. It is set to be the working date. Balance: What the debtor owes us.
Current: What the debtor owes that is less than 30 days old. 30 Days: What the debtor owes that is more than 30 days old, and less than 60 days old. 60 Days: What the debtor owes that is more than 60 days old, and less than 90 days old. 90 Days: What the debtor owes that is more than 90 days old.
Date: This column shows the original date the document was created. Type: This column shows the original source of the document type eg: Invoice, receipts, etc. Ref: This column shows the reference number of the original source document. Debit: The original Gross Value of the item for invoices etc. Credit: The original Gross Value of the item for cash receipts and credits. Balance: The net outstanding value of the item. N.B. Items will only appear if they have a non-zero Balance, or if zero when they have been subject to current period activity. The total of the Balance column should equal the balance of the account to the current period.
Compute: Clicking the Computer button will create a statement for the Debtor specified in the Name field. eMail: Clicking the email button will send a copy of the Statement document to the debtor using the address established in the Debtors Master Record. Account>: Clicking the Account button will take you to the Debtor - Account document.
